//
//  DataBaseHandle.h
//  旅游咨询
//
//  Created by Letme on 15-4-20.
//  Copyright (c) 2015年 xubin. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "HomePageModel.h"
@interface DataBaseHandle : NSObject
+(instancetype)shareDataBaseHandel;

- (void)openDB;
- (void)createForegin;
- (void)insertForegin:(HomePageModel *)myModel;
- (NSMutableArray *)selectAllForeginModel;
- (NSMutableArray *)selectAllEuropName;
- (void)dropAllErop;


- (void)createAsia;
- (void)insertAsia:(HomePageModel *)myModel;
- (NSMutableArray *)selectAllAsiaModel;
- (NSMutableArray *)selectAllAsiaName;
- (void)dropAllAsia;
- (void)deleteCountryInAsian:(NSString *)nameStr;


- (void)createAmerican;
- (void)insertAmerican:(HomePageModel *)myModel;
- (NSMutableArray *)selectAllAmericanModel;
- (NSMutableArray *)selectAllAmericanName;
- (void)dropAllAmerican;
@end
